psql \dt and table size

Поиск
Список
Период
Сортировка
От Bernd Helmle
Тема psql \dt and table size
Дата
Msg-id 11AFCA7F6987BE68E91C000D@[172.26.14.62]
обсуждение исходный текст
Ответы Re: psql \dt and table size  (David Fetter <david@fetter.org>)
Re: psql \dt and table size  (Susanne Ebrecht <susanne@2ndQuadrant.com>)
Список pgsql-hackers
It stroke me today again, that \dt+ isn't displaying the acurate table size
for tables, since it uses pg_relation_size() till now. With having
pg_table_size() since PostgreSQL 9.0 available, i believe it would be more
useful to have the total acquired storage displayed, including implicit
objects (the mentioned case where it was not very useful atm was a table
with a big TOAST table).

Attached minor patch extends \dt to use pg_table_size() starting with
PostgreSQL 9.0, not sure if we backport such changes though. It would be
interesting for 9.1, however.

--
Thanks

    Bernd
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Planner regression in 9.1: min(x) cannot use partial index with NOT NULL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Missing semicolon in parser's gram.y